﻿<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>表格条件查询</title>
    <script type="text/javascript" src="../../../Scripts/bootstrap/js/jquery.min.js"></script>
    <script src="../../../Scripts/QueryString.js" type="text/javascript"></script>
    <link href="../../../Scripts/easyUI145/themes/icon.css" rel="stylesheet" type="text/css" />
    <link href="../../../Scripts/easyUI145/themes/default/easyui.css" rel="stylesheet" type="text/css" />
    <link href="../../../../DataUser/Style/ccbpm.css" rel="stylesheet" type="text/css" />
    <!-- 引用通用的js文件. -->
    <script src="../../../Scripts/jquery-1.7.2.min.js" type="text/javascript"></script>
    <script src="../../../Scripts/easyUI/jquery.easyui.min.js" type="text/javascript"></script>
    <script src="../../../Scripts/EasyUIUtility.js" type="text/javascript"></script>
    <script type="text/javascript" src="../../../Scripts/config.js"></script>
    <script type="text/javascript" src="../../../Comm/Gener.js"></script>
    <script src="DDLBar.js" type="text/javascript"></script>
    <script type="text/javascript" language="javascript">
        //页面启动函数.
        $(function () {
            InitBar("PopTableSearch");
            var html = "";
            var mapExt = new Entity("BP.Sys.MapExt");
            mapExt.MyPK = "PopTableSearch_" + GetQueryString("FK_MapData") + "_" + GetQueryString("KeyOfEn");
            var i = mapExt.RetrieveFromDBSources(); //从数据库来查询.
            // alert(mapExt.Tag);
            //alert(mapExt.MyPK);

            if (mapExt.GetPara("SelectType") == "")
                mapExt.SetPara("SelectType", "1");

            if (mapExt.W <= 400)
                mapExt.W = 700;

            //alert(i);

            //批量为复制.
            GenerFullAllCtrlsVal(mapExt);

            //基本属性.
            // $("#TB_Title").val(mapExt.GetPara("Title"));
            //p").val(mapExt.GetPara("SearchTip"));
            // $("#TB_RootTreeNo").val(mapExt.GetPara("RootNo")); //树的根节点编号.

            //设置按钮是否可以用?
            if (i == 0) {
                $("#Btn_Delete").hide();
                $("#Btn_FullData").hide();
                $("#Btn_Gener").hide();
            }
        });
        function Save() {

            //更新节点表单类型.
            var frmID = GetQueryString("FK_MapData");
            var keyOfEn = GetQueryString("KeyOfEn");

            var en = new Entity("BP.Sys.MapAttr", frmID + "_" + keyOfEn);
            en.SetPara("PopModel", "PopTableSearch");
            en.Update();
            var mapExt = new Entity("BP.Sys.MapExt");
            mapExt.MyPK = "PopTableSearch_" + GetQueryString("FK_MapData") + "_" + GetQueryString("KeyOfEn");
            var count = mapExt.RetrieveFromDBSources(); //从数据库来查询.
            if (count == 0) {
                mapExt.SetPara("OpenPopType", 0);
                mapExt.SetPara("SelectType", 1);
            } else {
                if (mapExt.GetPara("OpenPopType") == undefined)
                    mapExt.SetPara("OpenPopType", 0);
                if (mapExt.GetPara("SelectType") == undefined)
                    mapExt.SetPara("SelectType", 1);
            }

            mapExt.CopyURL();  //从url里面copy数据.
            mapExt.CopyForm(); //从from里面copy数据.

            mapExt.ExtType = "PopTableSearch";
            mapExt.AttrOfOper = GetQueryString("KeyOfEn");


            var err = "";

            if (mapExt.GetPara("Title") == "")
                err += '\t\n必填字段[标题]不能为空';

            if (mapExt.Tag1 == "")
                err += '\t\n必填字段[搜索数据源]不能为空';

            if (mapExt.Tag2 == "")
                err += '\t\n必填字段[左侧树列表数据源]不能为空';

            if (mapExt.Tag == "")
                err += '\t\n必填字段[数据列名与中文意思对照]不能为空';

            if (mapExt.DBType == "")
                err += '\t\n必填字段[数据源类型]不能为空';

            var val = mapExt.Save();
            Reload();
        }
        function Delete() {

            if (confirm('您确定要删除吗？') == false)
                return;

            var mapExt = new Entity("BP.Sys.MapExt");
            mapExt.MyPK = "PopTableSearch_" + GetQueryString("FK_MapData") + "_" + GetQueryString("KeyOfEn");
            mapExt.RetrieveFromDBSources(); //从数据库来查询.
            mapExt.Delete();
            Reload();
        }

    </script>
    <style type="text/css">
        .style1 {
            height: 21px;
        }

        #bar {
            text-align: left;
        }

        .cs-content-box {
            padding: 0 5px;
        }
        .table a {
            color: #1c60be
        }

        .table ul {
            padding: 10px 0px;
        }

        .table li {
            list-style-type: none;
            line-height: 26px;
        }
    </style>
</head>
<body>
    <div class="container-full">
        <div id="bar">
        </div>
        <form id="cc">
            <table id="Table1" class="table">
                <tr>
                    <th colspan="2">
                        基本信息
                    </th>
                </tr>
 
                <tr>
                    <td>
                        <a href="javascript:alert('显示在搜索文本框的背景文字,比如：请输入付款人名称,进行搜索.')">搜索提示</a>
                    </td>
                    <td>
                        <input type="text" id="TBPara_SearchTip" name="TBPara_SearchTip" style="width: 99%;" />
                    </td>
                </tr>
                <tr>
                    <th colspan="2">
                        <a href="javascript:ShowHidden('PopValSearchCond')">查询条件设置</a>
                        <div id="PopValSearchCond" style="color: Gray; display: none">
                            <ul>
                                <li>该设置对table查询有效,(可以为空)：日期的默认值是JS函数表达式.</li>
                                <li>SQL格式为:</li>
                                <li>$Para=Dept#Label=所在班级#ListSQL=Select No,Name FROM Demo_BanJi </li>
                                <li>$Para=XB#Label=性别#EnumKey=XB</li>
                                <li>$Para=DTFrom#Label=注册日期从#DefVal=(new Date( (new Date().setDate(-30 + new Date().getDate()))))</li>
                                <li>$Para=DTTo#Label=到#DefVal=(new Date())</li>
                                <li>URL格式为:</li>
                                <li>$Para=Dept#Label=所在班级#ListURL=/DataUser/Handler.ashx?xxx=sss </li>
                                <li>执行CCFromRef.js返回JSON格式为:</li>
                                <li>$Para=Dept#Label=所在班级#ListFuncName=MyFunc </li>
                            </ul>
                        </div>
                    </th>
                </tr>
                <tr>
                    <td colspan="2">
                        <textarea id="TB_Tag1" name="TB_Tag1" style="width: 98%; height: 60px;">
                </textarea>
                    </td>
                </tr>
                <tr>
                    <th colspan="2">
                        <a href="javascript:ShowHidden('TablePage')">数据源</a>
                        <div id="TablePage" style="color: Gray; display: none">
                            <ul>
                                <li>设置一个查询的SQL语句，必须返回No,Name两个列。</li>
                                <li>该参数支持ccbpm表达式,比如:SELECT No, Name FROM WF_Emp WHERE FK_Dept='@WebUser.FK_Dept'</li>
                                <li>必须有：@PageCount @PageSize @Key 三个参数,分别标识:@PageCount =第几页, @PageSize=每页大小. @Key=关键字</li>
                                <li>
                                    比如For SQLServer: SELECT TOP @PageSize * FROM ( SELECT row_number() over(order by
                                    t.No) as rownumber,No,Name,Tel,Email FROM Demo_Student WHERE Name LIKE '%@Key%'
                                    ) A WHERE rownumber > @PageCount
                                    <br />
                                    总条数: SELECT COUNT(no) FROM Demo_Student WHERE (Name LIKE '%@Key%' OR No LIKE '%@Key%')
                                </li>
                                <li>
                                    比如For Oracle: SELECT No,Name,Email,Tel FROM Demo_Student WHERE (Name LIKE '%@Key%'
                                    OR No LIKE '%@Key%')
                                </li>
                                <li>
                                    比如For MySQL: SELECT No,Name,Email,Tel FROM Demo_Student WHERE (Name LIKE '%@Key%'
                                    OR No LIKE '%@Key%')
                                </li>
                                <li>添加的查询条件在为执行SQL查询时SQL语句后面不添加，解析的时候自动添加，其余的查询方式需要包含添加的查询条件</li>
                            </ul>
                        </div>
                    </th>
                </tr>
                <tr>
                    <td colspan="2">
                        <textarea id="TB_Tag2" name="TB_Tag2" style="width: 98%; height: 23px;">
                </textarea>
                    </td>
                </tr>

                <tr>
                    <th colspan="2">
                        <a href="javascript:ShowHidden('divTag')">数据列名与中文意思对照</a>
                        <div id="divTag" style="color: Gray; display: none">
                            <ul>
                                <li>该选项可以为空,在右上角的列表里查询或点树树干的数据源出现的列表,需要用中文显示列头..</li>
                                <li>格式为:</li>
                                <li>例如: No=编号,Name=名称,Addr=地址,Tel=电话,Email=邮件</li>
                            </ul>
                        </div>
                    </th>
                </tr>
                <tr>
                    <td colspan="2">
                        <input type="text" id="TB_Tag" name="TB_Tag" style="width: 99%;" />
                    </td>
                </tr>
                <tr>
                    <td colspan="2">
                        <a href="javascript:ShowHidden('backFunction')">确定后执行的JS</a>,可以为空.
                        <div id="backFunction" style="color: Gray; display: none">
                            <ul>
                                <li>该选项可以为空,弹出框确定后执行的JS，可以直接写方法名或者方法. </li>
                            </ul>
                        </div>
                    </td>
                </tr>
                <tr>
                    <td colspan="2">
                        <input type="text" id="TB_Tag5" name="TB_Tag5" style="width: 99%;" />
                    </td>
                </tr>
            </table>
        </form>
    </div>
</body>
</html>
